﻿CREATE TABLE [dbo].[UDS_SMS_MobileMsgSendBuffer] (
    [MsgID]             numeric(18,0) NOT NULL identity(1, 1),
    [Sender]            nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [RecipientMobileNo] nvarchar(20)   COLLATE Chinese_PRC_CI_AS NULL,
    [Content]           nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [SendTime]          datetime      NULL CONSTRAINT [DF_UDS_SMS_MobileMsgSendBuffer_SendTime] default((getdate())),
    [RepeatTimes]       int           NULL CONSTRAINT [DF_UDS_SMS_MobileMsgSendBuffer_RepeatTimes] default(((0))),
    [RepeatPeriod]      int           NULL,

    CONSTRAINT [PK_UDS_SMS_MobileMsgSendBuffer] PRIMARY KEY CLUSTERED ([MsgID] asc)
);
GO
